Re: ecpg - `exec sql delete' failing (fwd) - Mailing list pgsql-interfaces

At 3:28 +0100 on 6/4/98, Thomas Good wrote:


>
> scanf("%s", &reply);
> if(reply == 'y') {
> printf("\t\tEnter Client ID Number: ");
> scanf("%d", &delete_num);
> EXEC SQL DELETE FROM central WHERE client_id = delete_num;
> }
> else printf("Exiting...record not removed.\n");
>   exit(0);
> }

I've already told you about scanning into a char with %s - and you haven't
fixed it. Anyway, I have another suspicion - shouldn't the delete above be
"DELETE FROM central WHERE client_id = :delete_num" (with ":")?

Seems to me that without using colon, it may think that delet_num is a
column name.

Herouth